| |
|
Analysis of Reporting Services from Database in Sales Company and Suggestions of Changes
Zetocha, Adam ; Mucha, Robert (referee) ; Kříž, Jiří (advisor)
Bachelor thesis is dealing with problematic of collecting, saving and mainly creating reports from huge amount of data, which are collected by sales representatives directly from chains of retail stores. I am focused primarily on process of creating reports from data, which are stored in SQL databases of company through the licensed software Telerik report designer. My bachelor thesis is analysing effectivity of reporting itself through software mentioned above, and it is suggesting possible changes which may help to improve whole process.
|
|
MySQL and MS SQL Database Synchronization
Šimanovský, Filip ; Grégr, Matěj (referee) ; Trchalík, Roman (advisor)
This thesis describes the synchronization of MySQL and MS SQL databases . It explores and describes differences between these two database servers and further designs and implements alghorithms for their safety and economicaly favourable synchronization . Designed methods are implemented in a console application afterwards . Two case studies are used as an illustrative of its work . The result of this thesis is a manual on how to successfully convert MySQL database to MS SQL database (and vice versa ) and the convert application itself .
|
|
Proposal of SQL Database for E-Commerce
Kadleček, Tomáš ; Skoupý, David (referee) ; Kříž, Jiří (advisor)
This bachelor thesis deals about proposal and creating SQL database for e-commerce. Including theoretical part, analysis of present conditions and requirments and also practical part. In theoretical part we can find necessary informations to understand the databeses. Analysis of present conditions and requirments is focused to already working e-commerce, which is used as source of informations in practical part. Practical part is about own solution and benefits evaluation of database.
|
|
Automatic Largescale Processing of Testing Results
Klem, Richard ; Šnobl, Pavel (referee) ; Hruška, Tomáš (advisor)
This thesis deals with the issue of automated processing of large volumes of data in a relational database environment. The thesis focuses on the current situation in the Codasip company and solves the insufficiently fast implementation of materialized views updates. The result of the thesis is a draft to modify the current system. This draft successfully solves problems with slow data processing. The implemented solution then brought an average acceleration of the update of materialized views by 93 % and for some materialized views an acceleration of 99 %. This solution will help Codasip increase the efficiency of processor core development, as well as their other products. At the same time, this thesis can serve as a case study of optimizing slow database queries when processing large amounts of data.
|
| |
|
Marketing systems of construction SMEs
Muškát, Petr ; Vejtasa, Jan (referee) ; Dohnal, Radek (advisor)
The main objective of this thesis is to create an effective database system, which also serves as a source of information. The proposed system aims to facilitate and simplify the clarity of internal company information, about customers but also their employees. Then there is also the possibility to control workforce planning for individual contracts and globally but also meeting their the deadlines. We can notforget the marketing approach of the company and its public promotion.
|
|
Temporal XML Databases
Kunovský, Tomáš ; Zendulka, Jaroslav (referee) ; Rychlý, Marek (advisor)
The primary goal of this work is a implementation of temporal XML database in Java. There are described databases for XML documents and temporal databases with emphasis on their query languages and problem data storing is also analyzes for temporal databases. Source codes of the resulting application are public as open-source.
|
| |
|
Database Performance Tester
Šulaj, Martin ; Hujňák, Ondřej (referee) ; Očenáš, Martin (advisor)
Main goal goal of this project is to create tool for performance testing of relational databases and to prove his functionality. The tool is logically divided into 4 parts and every one of them can work independently. With the use of the tool we ca create, execute and evaluate test suites. Graphical visualisation of processed results is a part of the tool. The tool works with test suites that are executed on Raspberry Pi 3 B device and on well performing laptop. Databases that are tested with this tool are MySQL, PostgreSQL and SQLite.
|